SyServiceProcess 
Logical Entity Name  SyServiceProcess 
Default Table Name  SyServiceProcess 
Physical Only  NO 
Definition 
 
Note 
 

SyServiceProcess Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SyServiceProcessId(PK)    int  NO 
 
SyServiceProcessTypeId(FK)    int  NO 
 
Code    char(8)  NO 
 
Descrip    varchar(50)  NO 
 
Active    bit  NO 
 
Module    varchar(50)  NO 
 
WebServiceEndPoint    nvarchar(1000)  YES 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
ProcessInfoType    int  NO 
 
IsExceptionMgmtReady    bit  NO 
 

SyServiceProcess Primary and Unique Keys 
Key Name  Key Type  Keys 
Uk_SyServiceProcessCode  Index  Code 
Pk_SyServiceProcess_SyServiceProcessID  PrimaryKey  SyServiceProcessId 

SyServiceProcess Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SyServiceProcessType  Non-Identifying  One To Zero or More  FK_SyServiceProcessSyServiceProcessTypeId_SyServiceProcessTypeSyServiceProcessTypeId      SyServiceProcessTypeId  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  Fk_SyServiceProcessUserID_SyStaffSyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
SyAutomatedProcessActivation  Non-Identifying  One To Zero or More  FK_SyAutomatedProcessActivationSyServiceProcessID_SyServiceProcessSyServiceProcessID        NO  YES 
SyEventSinkSubscription  Non-Identifying  One To Zero or More  FK_SyEventSinkSubscriptionSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceExceptionTemplate  Non-Identifying  One To Zero or More  FK_SyServiceExceptionTemplateSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceProcessExportImportMapping  Non-Identifying  One To Zero or More  FK_SyServiceProcessExportImportMapping_SyServiceProcess_SyServiceProcessID_Exp        NO  YES 
SyServiceProcessExportImportMapping  Non-Identifying  One To Zero or More  FK_SyServiceProcessExportImportMapping_SyServiceProcess_SyServiceProcessID_Imp        NO  YES 
SyServiceProcessExportMaster  Non-Identifying  One To Zero or More  FK_SyServiceProcessExportMaster_SyServiceProcessID_SyServiceProcess_SyServiceProcessId        NO  YES 
SyServiceProcessImportMaster  Non-Identifying  One To Zero or More  FK_SyServiceProcessImportMasterSyServiceProcessID_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceProcessMapping  Non-Identifying  One To Zero or More  FK_SyServiceProcessMappingSyServiceProcessID_SyServiceProcessSyServiceProcessID        NO  YES 
SyServiceProcessSubscription  Non-Identifying  One To Zero or More  Fk_SyServiceProcessSubscriptionSyServiceProcessID_SyServiceProcessSyServiceProcessID        NO  YES 
SyServiceRequest  Non-Identifying  One To Zero or More  FK_SyServiceRequestSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceStarRequestQueue  Non-Identifying  One To Zero or More  FK_SyServiceStarRequestQueueSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceSubscriptionExceptionRoutingRelationship  Non-Identifying  One To Zero or More  FK_SyServiceSubscriptionExceptionRoutingRelationshipSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 
SyServiceSubscriptionNotificationRelationship  Non-Identifying  One To Zero or More  FK_SyServiceSubscriptionNotificationRelationshipSyServiceProcessId_SyServiceProcessSyServiceProcessId        NO  YES 

SyServiceProcess Check Constraints 
Check Constraint Name  CheckConstraint